﻿CREATE TABLE [dim].[Security] (
    [SecurityId]       INT            IDENTITY (1, 1) NOT NULL,
    [SecurityCode]     VARCHAR (16)   NOT NULL,
    [SecurityName]     NVARCHAR (100) NOT NULL,
    [SecurityTypeId]   INT            NOT NULL,
    [SecurityTypeName] VARCHAR (100)  NOT NULL,
    [IsFuture]         BIT            NULL,
    [IsInferedMember]  BIT            NOT NULL,
    [RowChecksumMD5]   CHAR (36)      NOT NULL,
    [RowAuditId]       INT            NOT NULL,
    PRIMARY KEY CLUSTERED ([SecurityId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

